package com.linln.modules.system.repository;

import com.linln.modules.system.domain.Order;
import com.linln.modules.system.domain.SmsLog;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

public interface SmsLogRepository extends BaseRepository<SmsLog, Long>, JpaSpecificationExecutor<SmsLog> {

    @Query(value = "SELECT * FROM `sys_sms_log` where order_no=:orderNo and scene_type=3 and receive_type=3 and DATE_FORMAT(create_date, '%Y-%m-%d') =:nowDay",nativeQuery = true)
    List<SmsLog> selectSmsLogList(String orderNo,String nowDay);
}
